Create database A3Fashion

CREATE TABLE Languages (
LanguageID VARCHAR(10) NOT NULL PRIMARY KEY,
LanguageName VARCHAR(255) NOT NULL
) 
CREATE TABLE Users (
UserID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
Username VARCHAR( 255 ) NOT NULL ,
Password VARCHAR( 30 ) NOT NULL ,
RoleID INT NOT NULL,
Avatar VARCHAR(255) NULL,
FirstName VARCHAR( 50 ) NOT NULL ,
LastName VARCHAR( 50 ) NOT NULL ,
AddressLine1 VARCHAR( 255 ) NOT NULL ,
AddressLine2 VARCHAR( 255 ) NOT NULL ,
City VARCHAR( 25 ) NOT NULL ,
PostalCode INT NOT NULL ,
Country VARCHAR( 25 ) NOT NULL ,
Phone VARCHAR( 25 ) NOT NULL ,
Email VARCHAR( 100 ) NOT NULL
)  

CREATE TABLE Product (
ProductID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
CategoryID INT NOT NULL,
ImageList VARCHAR( 255 ) NOT NULL ,
Price FLOAT NOT NULL ,
DateAdded DATETIME NOT NULL ,
Rating FLOAT NOT NULL ,
Likes INT NOT NULL,
BrandID INT NOT NULL ,
Sex VARCHAR( 10 ) NOT NULL,
ProductName VARCHAR( 50 ) NOT NULL
)  

CREATE TABLE  Product_translation(
ProductID INT NOT NULL,
LanguageID VARCHAR(10) NOT NULL ,
TranslationText VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( ProductID , LanguageID )
)  

CREATE TABLE  Brand (
BrandID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
BrandName VARCHAR( 50 ) NOT NULL
)
  
CREATE TABLE Rating (
ProductID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
Rating FLOAT NOT NULL ,
)  
CREATE TABLE Size (
SizeID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
Name INT NOT NULL ,
)  
CREATE TABLE Color (
ColorID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
Name VARCHAR( 25 ) NOT NULL
)  
CREATE TABLE Color_translation (
ColorID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
LanguageID VARCHAR(10) NOT NULL ,
TranslationText VARCHAR(50) NOT NULL 
)  
CREATE TABLE ProductDetail (
ProductDetailID INT NOT NULL IDENTITY(1,1) ,
ProductID INT NOT NULL ,
ColorID INT NOT NULL ,
SizeID INT NOT NULL ,
ImageList VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( ProductDetailID , ProductID , ColorID , SizeID )
) 

CREATE TABLE  Coupon (
CouponID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
ProductID INT NOT NULL ,
Value FLOAT NOT NULL ,
ExpiredDate DATETIME NOT NULL ,
StartDate DATETIME NOT NULL
)  

CREATE TABLE Category (
CategoryID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
Name VARCHAR( 100 ) NOT NULL 
)  
CREATE TABLE  Category_translation (
CategoryID INT NOT NULL IDENTITY(1,1) ,	
LanguageID VARCHAR(10) NOT NULL ,
TranslationText VARCHAR( 255 ) NOT NULL,
PRIMARY KEY(CategoryID, LanguageID)
)  

CREATE TABLE Orders (
OrderID INT NOT NULL IDENTITY(1,1) PRIMARY KEY ,
UserID INT NOT NULL,
TotalPrice FLOAT NOT NULL ,
OrderDate DATETIME NOT NULL ,
ShipDate DATETIME NOT NULL ,
CurrentStatus VARCHAR( 125 ) NOT NULL ,
AddressLine1 VARCHAR( 255 ) NOT NULL ,
AddressLine2 VARCHAR( 255 ) NULL ,
City VARCHAR( 255 ) NOT NULL ,
Postalcode INT NOT NULL ,
Country VARCHAR( 50 ) NOT NULL
)  
CREATE TABLE OrderDetail (
OrderID INT NOT NULL ,
ProductID INT NOT NULL ,
Quantity INT NOT NULL ,
Price INT NOT NULL ,
SizeID INT NOT NULL ,
ColorID INT NOT NULL ,
CouponID INT NULL 
)  
CREATE TABLE Exchange (
CurrencyID VARCHAR( 5 ) NOT NULL PRIMARY KEY,
Date DATETIME NOT NULL ,
CurrencyRate FLOAT NOT NULL 
) 

CREATE TABLE Roles(
RoleID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
RoleName VARCHAR(25) NOT NULL
) 

ALTER TABLE Users
ADD CONSTRAINT fk_roles_pid FOREIGN KEY(RoleID)REFERENCES Roles(RoleID)

ALTER TABLE Product
ADD CONSTRAINT fk_category_pid FOREIGN KEY(CategoryID) REFERENCES Category(CategoryID)

ALTER TABLE Product
ADD CONSTRAINT fk_brand_pid FOREIGN KEY(BrandID) REFERENCES Brand(BrandID)

ALTER TABLE Product_translation
ADD CONSTRAINT fk_languageProduct_pid FOREIGN KEY(LanguageID) REFERENCES Languages(LanguageID)

ALTER TABLE Color_translation
ADD CONSTRAINT fk_languageColor_pid FOREIGN KEY(LanguageID) REFERENCES Languages(LanguageID)

ALTER TABLE Rating
ADD CONSTRAINT fk_productRating_pid FOREIGN KEY(ProductID) REFERENCES Product(ProductID)

ALTER TABLE ProductDetail
ADD CONSTRAINT fk_productDetail_pid FOREIGN KEY(ProductID) REFERENCES Product(ProductID)

ALTER TABLE ProductDetail
ADD CONSTRAINT fk_colorProduct_pid FOREIGN KEY(ColorID) REFERENCES Color(ColorID)

ALTER TABLE ProductDetail
ADD CONSTRAINT fk_sizeProduct_pid FOREIGN KEY(SizeID) REFERENCES Size(SizeID)

ALTER TABLE Coupon
ADD CONSTRAINT fk_productCoupon_pid FOREIGN KEY(ProductID) REFERENCES Product(ProductID)

ALTER TABLE Category_translation
ADD CONSTRAINT fk_languageCategory_pid FOREIGN KEY(LanguageID) REFERENCES Languages(LanguageID)

ALTER TABLE Orders
ADD CONSTRAINT fk_userOrder_pid FOREIGN KEY(UserID) REFERENCES Users(UserID)

ALTER TABLE OrderDetail
ADD CONSTRAINT fk_orderDetail_pid FOREIGN KEY(OrderID) REFERENCES Orders(OrderID)

ALTER TABLE OrderDetail
ADD CONSTRAINT fk_productOrder_pid FOREIGN KEY(ProductID) REFERENCES Product(ProductID)

ALTER TABLE OrderDetail
ADD CONSTRAINT fk_sizeOrder_pid FOREIGN KEY(SizeID) REFERENCES Size(SizeID)

ALTER TABLE OrderDetail
ADD CONSTRAINT fk_colorOrder_pid FOREIGN KEY(ColorID) REFERENCES Color(ColorID)

ALTER TABLE OrderDetail
ADD CONSTRAINT fk_couponOrder_pid FOREIGN KEY(CouponID) REFERENCES Coupon(CouponID)




SET IDENTITY_INSERT Category ON
INSERT INTO Category (CategoryID,Name) VALUES (1,'T-Shirts')
INSERT INTO Category (CategoryID,Name) VALUES (2,'Jeans')
INSERT INTO Category (CategoryID,Name) VALUES (3,'Sweaters')
INSERT INTO Category (CategoryID,Name) VALUES (4,'Jumpsuits')
INSERT INTO Category (CategoryID,Name) VALUES (5,'Vest')
INSERT INTO Category (CategoryID,Name) VALUES (6,'Suit')
INSERT INTO Category (CategoryID,Name) VALUES (7,'Cardigans')
INSERT INTO Category (CategoryID,Name) VALUES (8,'Jackets')
INSERT INTO Category (CategoryID,Name) VALUES (9,'Dresses')
INSERT INTO Category (CategoryID,Name) VALUES (10,'Skirts')
INSERT INTO Category (CategoryID,Name) VALUES (11,'Blouses')
SET IDENTITY_INSERT Category OFF
select * from Category

INSERT INTO Roles (RoleName) Values ('Administrator')
INSERT INTO Roles (RoleName) Values ('Manager')
INSERT INTO Roles (RoleName) Values ('Customer')
INSERT INTO Roles (RoleName) Values ('Guest')
select * from Roles

INSERT INTO Color (Name) Values ('Red')
INSERT INTO Color (Name) Values ('Blue')
INSERT INTO Color (Name) Values ('Yellow')
INSERT INTO Color (Name) Values ('Black')
INSERT INTO Color (Name) Values ('White')
INSERT INTO Color (Name) Values ('Green')
INSERT INTO Color (Name) Values ('Gray')
INSERT INTO Color (Name) Values ('Purple')
INSERT INTO Color (Name) Values ('Pink')
INSERT INTO Color (Name) Values ('Brown')
INSERT INTO Color (Name) Values ('Orange')
INSERT INTO Color (Name) Values ('Violet')
INSERT INTO Color (Name) Values ('Ivory')
select * from Color


INSERT INTO Languages VALUES ('EN','English')
INSERT INTO Languages VALUES ('VN','Vietnamese')
select * from Languages

SET IDENTITY_INSERT Size ON
INSERT INTO Size (SizeID, Name) VALUES (1,32)
INSERT INTO Size (SizeID, Name) VALUES (2,33)
INSERT INTO Size (SizeID, Name) VALUES (4,35)
INSERT INTO Size (SizeID, Name) VALUES (5,36)
INSERT INTO Size (SizeID, Name) VALUES (7,38)
INSERT INTO Size (SizeID, Name) VALUES (8,39)
INSERT INTO Size (SizeID, Name) VALUES (9,40)
INSERT INTO Size (SizeID, Name) VALUES (10,41)
INSERT INTO Size (SizeID, Name) VALUES (11,42)
SET IDENTITY_INSERT Size OFF
select * from Size

INSERT INTO Brand (BrandName) VALUES ('Calvin Klein')
INSERT INTO Brand (BrandName) VALUES ('Armani Exchange')
INSERT INTO Brand (BrandName) VALUES ('Austin Reed')

INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'F-1.jpg',129,02-01-2011,5,0,1,'Female','F-1')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(2,'M-1.jpg',79.5,02-01-2011,3,0,1,'Male','M-1')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(2,'M-3.jpg',39.5,02-01-2011,2.5,0,1,'Male','M-3')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(3,'M-2.jpg',24.99,02-01-2011,2,0,1,'Male','M-2')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'M-4.jpg',495,02-01-2011,5,0,1,'Male','M-4')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-5.jpg',299.99,02-01-2011,4,0,1,'Male','M-5')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-6.jpg',219.99,02-01-2011,4,0,1,'Male','M-6')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-7.jpg',199.99,02-01-2011,3.5,0,1,'Male','M-7')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-8.jpg',178,02-01-2011,3.5,0,1,'Male','M-8')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-2.jpg',298,02-01-2011,4,0,1,'Female','F-2')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(10,'F-3.jpg',280,02-01-2011,4,0,1,'Female','F-3')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-4.jpg',280,02-01-2011,4,0,1,'Female','F-4')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-5.jpg',198,02-01-2011,4,0,1,'Female','F-5')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-6.jpg',198,02-01-2011,5,2,1,'Female','F-6')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'F-7.jpg',189.99,02-01-2011,4,0,1,'Female','F-7')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-8.jpg',189,02-01-2011,4,0,1,'Female','F-8')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'F-9.jpg',181.99,02-01-2011,4,0,1,'Female','F-9')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(10,'F-10.jpg',181.99,02-01-2011,4,0,1,'Female','F-10')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-11.jpg',179,02-01-2011,4,0,1,'Female','F-11')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-12.jpg',168,02-01-2011,3.5,0,1,'Female','F-12')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'F-13.jpg',139.99,02-01-2011,3,0,1,'Female','F-13')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-14.jpg',129,02-01-2011,3,0,1,'Female','F-14')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-15.jpg',59,02-01-2011,3,0,2,'Female','F-15')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-16.jpg',79,02-01-2011,3,0,2,'Female','F-16')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-17.jpg',79,02-01-2011,3,0,2,'Female','F-17')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-18.jpg',69,02-01-2011,3,0,2,'Female','F-18')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(9,'F-19.jpg',89,02-01-2011,3,0,2,'Female','F-19')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(3,'F-20.jpg',49,02-01-2011,3,0,2,'Female','F-20')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(3,'F-21.jpg',99,02-01-2011,4,0,2,'Female','F-21')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(3,'F-22.jpg',49,02-01-2011,4,0,2,'Female','F-22')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(1,'M-9.jpg',25,02-01-2011,2,0,2,'Male','M-9')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(1,'M-10.jpg',29,02-01-2011,2,0,2,'Male','M-10')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(1,'M-11.jpg',38,02-01-2011,2.5,0,2,'Male','M-11')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(3,'M-12.jpg',79,02-01-2011,3.5,0,2,'Male','M-12')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(3,'M-13.jpg',99,02-01-2011,4,0,2,'Male','M-13')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(3,'M-14.jpg',69,02-01-2011,3,0,2,'Male','M-14')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(2,'M-15.jpg',75,02-01-2011,3.5,0,3,'Male','M-15')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(2,'M-16.jpg',60,02-01-2011,3,0,3,'Male','M-16')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(2,'M-17.jpg',75,02-01-2011,3.5,0,3,'Male','M-17')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-18.jpg',345,02-01-2011,5,0,3,'Male','M-18')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-19.jpg',224,02-01-2011,4.5,0,3,'Male','M-19')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-20.jpg',300,02-01-2011,4.5,0,3,'Male','M-20')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(8,'M-21.jpg',500,02-01-2011,5,0,3,'Male','M-21')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(11,'F-23.jpg',90,02-01-2011,3,0,3,'Female','F-23')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(11,'F-24.jpg',100,02-01-2011,2.5,0,3,'Female','F-24')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'F-25.jpg',500,02-01-2011,5,0,3,'Female','F-25')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'F-26.jpg',465,02-01-2011,5,0,3,'Female','F-26')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'F-27.jpg',300,02-01-2011,4,0,3,'Female','F-27')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'F-28.jpg',400,02-01-2011,4.5,0,3,'Female','F-28')
INSERT INTO Product (CategoryID, ImageList, Price, DateAdded, Rating, Likes, BrandID,Sex,ProductName) VALUES 
(6,'F-29.jpg',370,02-01-2011,4.5,0,3,'Female','F-29')

select * from Product

INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (1,4,4,'F-1')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (2,4,5,'M-1')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (3,4,7,'M-3')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (4,7,8,'M-2')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (5,4,9,'M-4')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (6,4,10,'M-5')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (7,10,11,'M-6')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (8,4,9,'M-7')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (9,4,8,'M-8')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (10,4,7,'F-2')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (11,7,8,'F-3')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (12,4,9,'F-4')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (13,1,5,'F-5')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (14,5,2,'F-6')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (15,1,8,'F-7')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (16,5,7,'F-8')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (17,1,9,'F-9')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (18,7,1,'F-10')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (19,5,11,'F-11')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (20,2,10,'F-12')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (21,2,5,'F-13')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (22,11,4,'F-14')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (23,4,7,'F-15')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (24,5,8,'F-16')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (25,7,9,'F-17')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (26,2,10,'F-18')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (27,4,9,'F-19')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (28,4,7,'F-20')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (29,11,8,'F-21')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (30,1,5,'F-22')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (31,2,4,'M-9')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (32,7,7,'M-10')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (33,7,8,'M-11')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (34,4,9,'M-12')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (35,4,5,'M-13')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (36,4,5,'M-14')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (37,2,5,'M-15')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (38,4,10,'M-16')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (39,2,8,'M-17')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (40,7,7,'M-18')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (41,4,9,'M-19')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (42,4,9,'M-20')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (43,4,5,'M-21')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (44,4,2,'F-23')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (45,5,8,'F-24')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (46,4,7,'F-25')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (47,4,111,'F-26')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (48,4,1,'F-27')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (49,4,8,'F-28')
INSERT INTO ProductDetail (ProductID, ColorID, SizeID,ImageList) Values (50,7,8,'F-29')

select * from ProductDetail